﻿CREATE TABLE [dbo].[ObjectReferences](
	[SiteID] [uniqueidentifier] NOT NULL,
	[WebID] [uniqueidentifier] NOT NULL,
	[ReferenceID] [nvarchar](512) NOT NULL,
	[ObjectID] [nvarchar](512) NOT NULL,
	[Name] [nvarchar](255) NOT NULL,
	[ReferenceType] [tinyint] NOT NULL,
	[Url] [nvarchar](255) NOT NULL,
	[SiteTitle] [nvarchar](255) NOT NULL,
	[SiteUrl] [nvarchar](255) NOT NULL,
	[ListTitle] [nvarchar](255) NULL,
	[ListUrl] [nvarchar](255) NULL
) ON [PRIMARY]

GO
-- =============================================
CREATE PROCEDURE [dbo].[DeleteObjectReferences]
	@SiteID UniqueIdentifier,
	@WebID UniqueIdentifier
AS
BEGIN
	delete
	from
		ObjectReferences
	where
		SiteID=@SiteID and WebID=@WebID
END
